Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	2988
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	291.8 KiB
Average record size in memory	100.0 B

Variable types

Numeric	12

Alerts

`gross_revenue` is highly overall correlated with `qty_invoices` and 3 other fields	High correlation
`qty_invoices` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`qty_items_purchased` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`products_variety` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly overall correlated with `avg_variety_basket`	High correlation
`recency_days` is highly overall correlated with `qty_invoices`	High correlation
`avg_recency_days` is highly overall correlated with `avg_freq_days`	High correlation
`avg_freq_days` is highly overall correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly overall correlated with `gross_revenue`	High correlation
`avg_variety_basket` is highly overall correlated with `qty_items_purchased` and 2 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 53.59467161)	Skewed
`total_return` is highly skewed (γ1 = 52.87135559)	Skewed
`avg_basket_size` is highly skewed (γ1 = 44.74538965)	Skewed
`customer_id` has unique values	Unique
`recency_days` has 34 (1.1%) zeros	Zeros
`total_return` has 1500 (50.2%) zeros	Zeros

Reproduction

Analysis started	2023-01-23 14:59:05.285487
Analysis finished	2023-01-23 14:59:30.499279
Duration	25.21 seconds
Software version	pandas-profiling vdev
Download configuration	config.json

customer_id
Real number (ℝ)

Distinct	2988
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15269.023

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	35.0 KiB

Quantile statistics

Minimum	12347
5-th percentile	12613.7
Q1	13791.75
median	15220.5
Q3	16770.25
95-th percentile	17964.65
Maximum	18287
Range	5940
Interquartile range (IQR)	2978.5

Descriptive statistics

Standard deviation	1721.2688
Coefficient of variation (CV)	0.11272946
Kurtosis	-1.2079407
Mean	15269.023
Median Absolute Deviation (MAD)	1490.5
Skewness	0.029601368
Sum	45623840
Variance	2962766.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
16146	1	< 0.1%
17588	1	< 0.1%
14759	1	< 0.1%
16185	1	< 0.1%
13505	1	< 0.1%
13389	1	< 0.1%
17631	1	< 0.1%
17061	1	< 0.1%
17630	1	< 0.1%
Other values (2978)	2978	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12363	1	< 0.1%
12364	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

gross_revenue
Real number (ℝ)

Distinct	2973
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2733.3693

Minimum	5.9
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	5.9
5-th percentile	227.5565
Q1	566.595
median	1079.475
Q3	2298.94
95-th percentile	7169.562
Maximum	279138.02
Range	279132.12
Interquartile range (IQR)	1732.345

Descriptive statistics

Standard deviation	10528.004
Coefficient of variation (CV)	3.851658
Kurtosis	357.67231
Mean	2733.3693
Median Absolute Deviation (MAD)	667.97
Skewness	16.852986
Sum	8167307.5
Variance	1.1083887 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
533.33	2	0.1%
178.96	2	0.1%
2053.02	2	0.1%
331	2	0.1%
889.93	2	0.1%
1314.45	2	0.1%
2092.32	2	0.1%
745.06	2	0.1%
598.2	2	0.1%
379.65	2	0.1%
Other values (2963)	2968	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5.9	1	< 0.1%
6.2	1	< 0.1%
13.3	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
63	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
136275.72	1	< 0.1%
124564.53	1	< 0.1%
116729.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%

qty_invoices
Real number (ℝ)

Distinct	57
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.6904284

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.8214944
Coefficient of variation (CV)	1.5502338
Kurtosis	191.08365
Mean	5.6904284
Median Absolute Deviation (MAD)	2
Skewness	10.766552
Sum	17003
Variance	77.818763
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	789	26.4%
3	498	16.7%
4	394	13.2%
5	236	7.9%
1	206	6.9%
6	173	5.8%
7	139	4.7%
8	98	3.3%
9	69	2.3%
10	54	1.8%
Other values (47)	332	11.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	206	6.9%
2	789	26.4%
3	498	16.7%
4	394	13.2%
5	236	7.9%
6	173	5.8%
7	139	4.7%
8	98	3.3%
9	69	2.3%
10	54	1.8%

Value	Count	Frequency (%)
206	1	< 0.1%
198	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	1	< 0.1%
90	1	< 0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%

qty_items_purchased
Real number (ℝ)

Distinct	467
Distinct (%)	15.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.08936

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	29
median	66
Q3	135
95-th percentile	382
Maximum	7838
Range	7837
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	268.54062
Coefficient of variation (CV)	2.1995416
Kurtosis	356.32989
Mean	122.08936
Median Absolute Deviation (MAD)	44
Skewness	15.718178
Sum	364803
Variance	72114.062
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	44	1.5%
20	37	1.2%
35	35	1.2%
15	34	1.1%
19	34	1.1%
29	34	1.1%
11	33	1.1%
25	32	1.1%
16	30	1.0%
27	30	1.0%
Other values (457)	2645	88.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	7	0.2%
2	14	0.5%
3	16	0.5%
4	17	0.6%
5	28	0.9%
6	28	0.9%
7	19	0.6%
8	19	0.6%
9	26	0.9%
10	28	0.9%

Value	Count	Frequency (%)
7838	1	< 0.1%
5589	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2697	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1672	1	< 0.1%
1637	1	< 0.1%

products_variety
Real number (ℝ)

Distinct	339
Distinct (%)	11.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.993641

Minimum	1
Maximum	1785
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	1
5-th percentile	7
Q1	25
median	52
Q3	100
95-th percentile	233
Maximum	1785
Range	1784
Interquartile range (IQR)	75

Descriptive statistics

Standard deviation	96.628745
Coefficient of variation (CV)	1.2232471
Kurtosis	82.657166
Mean	78.993641
Median Absolute Deviation (MAD)	33
Skewness	6.3984328
Sum	236033
Variance	9337.1145
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24	44	1.5%
18	42	1.4%
37	40	1.3%
28	40	1.3%
25	37	1.2%
15	37	1.2%
11	37	1.2%
26	37	1.2%
23	36	1.2%
30	36	1.2%
Other values (329)	2602	87.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	26	0.9%
2	16	0.5%
3	21	0.7%
4	20	0.7%
5	35	1.2%
6	22	0.7%
7	26	0.9%
8	30	1.0%
9	32	1.1%
10	27	0.9%

Value	Count	Frequency (%)
1785	1	< 0.1%
1766	1	< 0.1%
1322	1	< 0.1%
1118	1	< 0.1%
884	1	< 0.1%
816	1	< 0.1%
717	1	< 0.1%
713	1	< 0.1%
699	1	< 0.1%
636	1	< 0.1%

avg_ticket
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	2986
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51.975057

Minimum	2.1505882
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	2.1505882
5-th percentile	4.9317949
Q1	13.113004
median	17.936066
Q3	24.843993
95-th percentile	90.498417
Maximum	56157.5
Range	56155.349
Interquartile range (IQR)	11.730989

Descriptive statistics

Standard deviation	1033.7604
Coefficient of variation (CV)	19.889548
Kurtosis	2907.723
Mean	51.975057
Median Absolute Deviation (MAD)	5.9616373
Skewness	53.594672
Sum	155301.47
Variance	1068660.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.162	2	0.1%
14.47833333	2	0.1%
25.31482759	1	< 0.1%
53.92173913	1	< 0.1%
15.94088235	1	< 0.1%
17.07774194	1	< 0.1%
17.22099526	1	< 0.1%
15.64627451	1	< 0.1%
13.54692308	1	< 0.1%
52.85080808	1	< 0.1%
Other values (2976)	2976	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
3202.92	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
931.5	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%

recency_days
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	272
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.796519

Minimum	0
Maximum	373
Zeros	34
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	32
Q3	84
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	73

Descriptive statistics

Standard deviation	78.084432
Coefficient of variation (CV)	1.2050714
Kurtosis	2.7170346
Mean	64.796519
Median Absolute Deviation (MAD)	26
Skewness	1.7841812
Sum	193612
Variance	6097.1785
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
3	85	2.8%
2	84	2.8%
8	76	2.5%
10	67	2.2%
7	66	2.2%
9	66	2.2%
17	64	2.1%
15	55	1.8%
Other values (262)	2239	74.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	34	1.1%
1	99	3.3%
2	84	2.8%
3	85	2.8%
4	87	2.9%
5	43	1.4%
7	66	2.2%
8	76	2.5%
9	66	2.2%
10	67	2.2%

Value	Count	Frequency (%)
373	2	0.1%
372	3	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	3	0.1%
364	1	< 0.1%
360	2	0.1%
359	1	< 0.1%
358	4	0.1%

avg_recency_days
Real number (ℝ)

Distinct	1254
Distinct (%)	42.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	66.898942

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	1
5-th percentile	7.4458838
Q1	25.276786
median	47.666667
Q3	85
95-th percentile	201
Maximum	366
Range	365
Interquartile range (IQR)	59.723214

Descriptive statistics

Standard deviation	63.463411
Coefficient of variation (CV)	0.94864597
Kurtosis	4.9415397
Mean	66.898942
Median Absolute Deviation (MAD)	26.143939
Skewness	2.0734536
Sum	199894.04
Variance	4027.6046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	24	0.8%
4	23	0.8%
70	22	0.7%
7	20	0.7%
1	19	0.6%
46	18	0.6%
21	18	0.6%
35	18	0.6%
11	18	0.6%
49	18	0.6%
Other values (1244)	2790	93.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	19	0.6%
1.5	1	< 0.1%
2	14	0.5%
2.5	1	< 0.1%
2.565517241	1	< 0.1%
3	15	0.5%
3.271929825	1	< 0.1%
3.321428571	1	< 0.1%
3.5	2	0.1%
4	23	0.8%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

avg_freq_days
Real number (ℝ)

Distinct	1223
Distinct (%)	40.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44.664859

Minimum	0.058823529
Maximum	183.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	0.058823529
5-th percentile	1
Q1	19.986111
median	38.472222
Q3	61
95-th percentile	112.33333
Maximum	183.5
Range	183.44118
Interquartile range (IQR)	41.013889

Descriptive statistics

Standard deviation	34.172562
Coefficient of variation (CV)	0.76508831
Kurtosis	1.8971383
Mean	44.664859
Median Absolute Deviation (MAD)	20.472222
Skewness	1.2356761
Sum	133458.6
Variance	1167.764
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	214	7.2%
16	18	0.6%
36	17	0.6%
42	16	0.5%
29	15	0.5%
11	15	0.5%
12	15	0.5%
34	14	0.5%
47	13	0.4%
39	13	0.4%
Other values (1213)	2638	88.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.05882352941	1	< 0.1%
0.3333333333	1	< 0.1%
0.5	7	0.2%
0.875	1	< 0.1%
1	214	7.2%
1.333333333	1	< 0.1%
1.5	3	0.1%
1.815533981	1	< 0.1%
1.883838384	1	< 0.1%
2	3	0.1%

Value	Count	Frequency (%)
183.5	1	< 0.1%
183	1	< 0.1%
182.5	1	< 0.1%
182	1	< 0.1%
179	2	0.1%
178.5	1	< 0.1%
178	2	0.1%
176.5	1	< 0.1%
176	2	0.1%
175.5	3	0.1%

total_return
Real number (ℝ)

SKEWED ZEROS

Distinct	173
Distinct (%)	5.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51.872155

Minimum	-0
Maximum	80995
Zeros	1500
Zeros (%)	50.2%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	-0
5-th percentile	0
Q1	-0
median	-0
Q3	6
95-th percentile	61.65
Maximum	80995
Range	80995
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	1498.6991
Coefficient of variation (CV)	28.892169
Kurtosis	2851.7806
Mean	51.872155
Median Absolute Deviation (MAD)	0
Skewness	52.871356
Sum	154994
Variance	2246099
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0	1500	50.2%
1	295	9.9%
3	169	5.7%
6	93	3.1%
2	88	2.9%
4	71	2.4%
5	43	1.4%
12	43	1.4%
8	40	1.3%
7	38	1.3%
Other values (163)	608	20.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0	1500	50.2%
1	295	9.9%
2	88	2.9%
3	169	5.7%
4	71	2.4%
5	43	1.4%
6	93	3.1%
7	38	1.3%
8	40	1.3%
9	36	1.2%

Value	Count	Frequency (%)
80995	1	< 0.1%
9014	1	< 0.1%
4824	1	< 0.1%
4027	1	< 0.1%
2302	2	0.1%
1776	1	< 0.1%
1608	1	< 0.1%
1589	1	< 0.1%
1515	1	< 0.1%
1278	1	< 0.1%

avg_basket_size
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1986
Distinct (%)	66.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	250.2186

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	1
5-th percentile	44.077778
Q1	103.2875
median	172.29167
Q3	282.08333
95-th percentile	600
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	178.79583

Descriptive statistics

Standard deviation	789.44209
Coefficient of variation (CV)	3.1550097
Kurtosis	2265.1771
Mean	250.2186
Median Absolute Deviation (MAD)	83.25
Skewness	44.74539
Sum	747653.16
Variance	623218.81
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	11	0.4%
82	9	0.3%
86	9	0.3%
136	9	0.3%
73	9	0.3%
60	9	0.3%
88	8	0.3%
75	8	0.3%
140	8	0.3%
Other values (1976)	2897	97.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	2	0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%

avg_variety_basket
Real number (ℝ)

Distinct	911
Distinct (%)	30.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.536632

Minimum	0.2
Maximum	259
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	46.7 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	7.6989247
median	13.625
Q3	22.2
95-th percentile	46
Maximum	259
Range	258.8
Interquartile range (IQR)	14.501075

Descriptive statistics

Standard deviation	15.487218
Coefficient of variation (CV)	0.88313525
Kurtosis	28.890184
Mean	17.536632
Median Absolute Deviation (MAD)	6.625
Skewness	3.4054
Sum	52399.456
Variance	239.85391
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	43	1.4%
9	42	1.4%
16	40	1.3%
8	39	1.3%
14	39	1.3%
17	38	1.3%
5	38	1.3%
7	38	1.3%
11	37	1.2%
15	35	1.2%
Other values (901)	2599	87.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	6	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.4%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
259	1	< 0.1%
177	1	< 0.1%
148	1	< 0.1%
127	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
101	1	< 0.1%
98	1	< 0.1%
95.5	1	< 0.1%
94.33333333	1	< 0.1%

Auto

Heatmap
Table

	customer_id	gross_revenue	qty_invoices	qty_items_purchased	products_variety	avg_ticket	recency_days	avg_recency_days	avg_freq_days	total_return	avg_basket_size	avg_variety_basket
customer_id	1.000	-0.076	0.027	0.011	0.006	-0.129	0.001	0.024	0.002	-0.062	-0.124	-0.020
gross_revenue	-0.076	1.000	0.771	0.745	0.666	0.247	-0.417	-0.249	-0.079	0.363	0.573	0.104
qty_invoices	0.027	0.771	1.000	0.691	0.585	0.061	-0.506	-0.251	-0.060	0.289	0.098	-0.182
qty_items_purchased	0.011	0.745	0.691	1.000	0.972	-0.374	-0.438	-0.162	-0.025	0.231	0.381	0.513
products_variety	0.006	0.666	0.585	0.972	1.000	-0.453	-0.383	-0.110	0.011	0.195	0.384	0.636
avg_ticket	-0.129	0.247	0.061	-0.374	-0.453	1.000	0.047	-0.127	-0.087	0.198	0.190	-0.615
recency_days	0.001	-0.417	-0.506	-0.438	-0.383	0.047	1.000	0.106	-0.028	-0.121	-0.096	0.017
avg_recency_days	0.024	-0.249	-0.251	-0.162	-0.110	-0.127	0.106	1.000	0.871	-0.387	-0.086	0.128
avg_freq_days	0.002	-0.079	-0.060	-0.025	0.011	-0.087	-0.028	0.871	1.000	-0.223	-0.028	0.115
total_return	-0.062	0.363	0.289	0.231	0.195	0.198	-0.121	-0.387	-0.223	1.000	0.208	-0.064
avg_basket_size	-0.124	0.573	0.098	0.381	0.384	0.190	-0.096	-0.086	-0.028	0.208	1.000	0.403
avg_variety_basket	-0.020	0.104	-0.182	0.513	0.636	-0.615	0.017	0.128	0.115	-0.064	0.403	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	gross_revenue	qty_invoices	qty_items_purchased	products_variety	avg_ticket	recency_days	avg_recency_days	avg_freq_days	total_return	avg_basket_size	avg_variety_basket
0	17850	5391.21	34.0	297.0	21.0	18.152222	372.0	35.500000	0.058824	21.0	50.970588	0.617647
1	13047	3232.59	9.0	171.0	105.0	18.904035	56.0	26.307692	35.333333	6.0	154.444444	11.666667
2	12583	6705.38	15.0	232.0	114.0	28.902500	2.0	21.823529	24.800000	50.0	335.200000	7.600000
3	13748	948.25	5.0	28.0	24.0	33.866071	95.0	92.666667	55.800000	-0.0	87.800000	4.800000
4	15100	876.00	3.0	3.0	1.0	292.000000	333.0	8.600000	13.666667	22.0	26.666667	0.333333
5	15291	4623.30	14.0	102.0	61.0	45.326471	25.0	21.750000	24.928571	27.0	150.142857	4.357143
6	14688	5630.87	21.0	327.0	148.0	17.219786	7.0	18.300000	17.476190	281.0	172.428571	7.047619
7	17809	5411.91	12.0	61.0	46.0	88.719836	16.0	32.454545	29.833333	41.0	171.416667	3.833333
8	15311	60767.90	91.0	2379.0	567.0	25.543464	0.0	4.144444	4.109890	231.0	419.714286	6.230769
9	16098	2005.63	7.0	67.0	34.0	29.934776	87.0	47.666667	41.000000	-0.0	87.571429	4.857143

	customer_id	gross_revenue	qty_invoices	qty_items_purchased	products_variety	avg_ticket	recency_days	avg_recency_days	avg_freq_days	total_return	avg_basket_size	avg_variety_basket
5612	17727	1060.25	1.0	66.0	66.0	16.064394	15.0	6.0	1.000000	6.0	645.000000	66.000000
5622	17232	421.52	2.0	36.0	30.0	11.708889	2.0	12.0	6.500000	-0.0	101.500000	15.000000
5623	17468	137.00	2.0	5.0	5.0	27.400000	10.0	4.0	2.500000	-0.0	58.000000	2.500000
5634	13596	697.04	2.0	166.0	133.0	4.199036	5.0	7.0	4.000000	-0.0	203.000000	66.500000
5640	14893	1237.85	2.0	73.0	72.0	16.956849	9.0	2.0	1.500000	-0.0	399.500000	36.000000
5644	12479	473.20	1.0	30.0	30.0	15.773333	11.0	4.0	1.000000	34.0	382.000000	30.000000
5665	14126	706.13	3.0	15.0	14.0	47.075333	7.0	3.0	1.333333	50.0	169.333333	4.666667
5671	13521	1092.39	3.0	435.0	312.0	2.511241	1.0	4.5	3.333333	-0.0	244.333333	104.000000
5681	15060	301.84	4.0	120.0	80.0	2.515333	8.0	1.0	0.500000	-0.0	65.500000	20.000000
5700	12558	269.96	1.0	11.0	11.0	24.541818	7.0	6.0	1.000000	102.0	196.000000	11.000000

Overview

Variables

Interactions

Correlations

Missing values

Sample